package com.chey.dao;

import com.chey.domain.Day;
import com.chey.domain.Area;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author JanYao
 * @version 0.1
 */
@Mapper
public interface EchartsDao {

    @Select("select *from area")
    public Area getEchartsAreaData();

    @Select("select * from ENTRY_VIEW")
    public List<Day> getEchartsAData();
    @Select("select * from OUT_VIEW")
    public List<Day> getEchartsDData();

    @Select("select count(*) from dfoe_dfdl_dflt where dflt_iast='CAN' ")
    public Integer getCancelCounts();

    @Select("select count(*) from dfoe_dfdl_dflt where dflt_iast='DLY' ")
    public Integer getDelayCounts();

}
